SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

-- =============================================
-- Author:		LAXMAN
-- Create date: October 2nd 2009
-- Description:	To change the First Letter to lower case
-- Ex: I/P: Vara Prasad  O/P: vara Prasad
-- =============================================




CREATE FUNCTION [dbo].[fn_Convert_FirstLower]-- 'VARA PRASAD'
    (
        @word    varchar(500)
    )
RETURNS varchar(500)

AS

BEGIN 



    SET @word =(SELECT Lower(substring(@word,1,1)) + SUBSTRING(@word,2,len(@word)-1))
    RETURN @word

END


GO
